This notebook is a basic example of how interactive SAS Procedures can be used across notebook cells.

I couldn't find an exhaustive list of interactive procedures but here are some examples

PROC IML
PROC SQL
PROC OPTMODEL
PROC REG
PROC DATASETS

WARNING: The color syntaxing will likely not work as desired for procedures split across cells because the syntax state isn't stored across cells



In [1]:

    
proc sql;
select count(*)
from sashelp.class;









    Out[1]:










SAS Output



SAS Output


The SAS System 

The SQL Procedure

Query Results




  




19



In [2]:

    
create table foo as
select * from sashelp.class;









    Out[2]:










SAS Output



SAS Output



In [3]:

    
select * 
from foo;
quit;









    Out[3]:










SAS Output



SAS Output


The SAS System 

The SQL Procedure

Query Results




Name
Sex
Age
Height
Weight




Alfred
M
14
69
112.5


Alice
F
13
56.5
84


Barbara
F
13
65.3
98


Carol
F
14
62.8
102.5


Henry
M
14
63.5
102.5


James
M
12
57.3
83


Jane
F
12
59.8
84.5


Janet
F
15
62.5
112.5


Jeffrey
M
13
62.5
84


John
M
12
59
99.5


Joyce
F
11
51.3
50.5


Judy
F
14
64.3
90


Louise
F
12
56.3
77


Mary
F
15
66.5
112


Philip
M
16
72
150


Robert
M
12
64.8
128


Ronald
M
15
67
133


Thomas
M
11
57.5
85


William
M
15
66.5
112

Name	Sex	Age	Height	Weight
Alfred	M	14	69	112.5
Alice	F	13	56.5	84
Barbara	F	13	65.3	98
Carol	F	14	62.8	102.5
Henry	M	14	63.5	102.5
James	M	12	57.3	83
Jane	F	12	59.8	84.5
Janet	F	15	62.5	112.5
Jeffrey	M	13	62.5	84
John	M	12	59	99.5
Joyce	F	11	51.3	50.5
Judy	F	14	64.3	90
Louise	F	12	56.3	77
Mary	F	15	66.5	112
Philip	M	16	72	150
Robert	M	12	64.8	128
Ronald	M	15	67	133
Thomas	M	11	57.5	85
William	M	15	66.5	112